from openpyxl import Workbook
wb=Workbook()
ws=wb.active
for i in range(1,5):
    wb.create_sheet("Sheet2",i)
print(wb.sheetnames)

wb.save("D://xuan.xlsx")